<?xml version="1.0" encoding="UTF-8"?>
<dataSource name="ishop2@localhost">
  <database-model serializer="dbm" rdbms="MYSQL" format-version="4.2">
    <root id="1"/>
    <schema id="2" parent="1" name="ishop2">
      <Current>1</Current>
      <Visible>1</Visible>
    </schema>
    <schema id="3" parent="1" name="angularjs"/>
    <schema id="4" parent="1" name="cake"/>
    <schema id="5" parent="1" name="cake_mini"/>
    <schema id="6" parent="1" name="catalog"/>
    <schema id="7" parent="1" name="dle"/>
    <schema id="8" parent="1" name="fw"/>
    <schema id="9" parent="1" name="information_schema"/>
    <schema id="10" parent="1" name="mysql"/>
    <schema id="11" parent="1" name="oc"/>
    <schema id="12" parent="1" name="oc21"/>
    <schema id="13" parent="1" name="ocstore"/>
    <schema id="14" parent="1" name="opencart"/>
    <schema id="15" parent="1" name="performance_schema"/>
    <schema id="16" parent="1" name="test"/>
    <schema id="17" parent="1" name="wordpress"/>
    <schema id="18" parent="1" name="world"/>
    <schema id="19" parent="1" name="yii2_loc"/>
    <schema id="20" parent="1" name="yii2_mini"/>
    <table id="21" parent="2" name="attribute_group"/>
    <table id="22" parent="2" name="attribute_product"/>
    <table id="23" parent="2" name="attribute_value"/>
    <table id="24" parent="2" name="brand"/>
    <table id="25" parent="2" name="category"/>
    <table id="26" parent="2" name="currency"/>
    <table id="27" parent="2" name="gallery"/>
    <table id="28" parent="2" name="modification"/>
    <table id="29" parent="2" name="order"/>
    <table id="30" parent="2" name="order_product"/>
    <table id="31" parent="2" name="product"/>
    <table id="32" parent="2" name="related_product"/>
    <table id="33" parent="2" name="user"/>
    <column id="34" parent="21" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="35" parent="21" name="title">
      <Position>2</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <key id="36" parent="21" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <column id="37" parent="22" name="attr_id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="38" parent="22" name="product_id">
      <Position>2</Position>
      <DataType>int(11) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <key id="39" parent="22" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>attr_id
product_id</ColNames>
      <Primary>1</Primary>
    </key>
    <column id="40" parent="23" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="41" parent="23" name="value">
      <Position>2</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="42" parent="23" name="attr_group_id">
      <Position>3</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <index id="43" parent="23" name="attr_group_id">
      <ColNames>attr_group_id</ColNames>
    </index>
    <index id="44" parent="23" name="value">
      <ColNames>value</ColNames>
      <Unique>1</Unique>
    </index>
    <key id="45" parent="23" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <key id="46" parent="23" name="value">
      <ColNames>value</ColNames>
      <UnderlyingIndexName>value</UnderlyingIndexName>
    </key>
    <column id="47" parent="24" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="48" parent="24" name="title">
      <Position>2</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="49" parent="24" name="alias">
      <Position>3</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="50" parent="24" name="img">
      <Position>4</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;brand_no_image.jpg&apos;</DefaultExpression>
    </column>
    <column id="51" parent="24" name="description">
      <Position>5</Position>
      <DataType>varchar(255)|0</DataType>
    </column>
    <index id="52" parent="24" name="alias">
      <ColNames>alias</ColNames>
      <Unique>1</Unique>
    </index>
    <key id="53" parent="24" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <key id="54" parent="24" name="alias">
      <ColNames>alias</ColNames>
      <UnderlyingIndexName>alias</UnderlyingIndexName>
    </key>
    <column id="55" parent="25" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="56" parent="25" name="title">
      <Position>2</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="57" parent="25" name="alias">
      <Position>3</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="58" parent="25" name="parent_id">
      <Position>4</Position>
      <DataType>tinyint(3) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;0&apos;</DefaultExpression>
    </column>
    <column id="59" parent="25" name="keywords">
      <Position>5</Position>
      <DataType>varchar(255)|0</DataType>
    </column>
    <column id="60" parent="25" name="description">
      <Position>6</Position>
      <DataType>varchar(255)|0</DataType>
    </column>
    <index id="61" parent="25" name="alias">
      <ColNames>alias</ColNames>
      <Unique>1</Unique>
    </index>
    <key id="62" parent="25" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <key id="63" parent="25" name="alias">
      <ColNames>alias</ColNames>
      <UnderlyingIndexName>alias</UnderlyingIndexName>
    </key>
    <column id="64" parent="26" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="65" parent="26" name="title">
      <Position>2</Position>
      <DataType>varchar(50)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="66" parent="26" name="code">
      <Position>3</Position>
      <DataType>varchar(3)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="67" parent="26" name="symbol_left">
      <Position>4</Position>
      <DataType>varchar(10)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="68" parent="26" name="symbol_right">
      <Position>5</Position>
      <DataType>varchar(10)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="69" parent="26" name="value">
      <Position>6</Position>
      <DataType>float(15,2)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="70" parent="26" name="base">
      <Position>7</Position>
      <DataType>enum(&apos;0&apos;, &apos;1&apos;)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <key id="71" parent="26" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <column id="72" parent="27" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="73" parent="27" name="product_id">
      <Position>2</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="74" parent="27" name="img">
      <Position>3</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <key id="75" parent="27" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <column id="76" parent="28" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="77" parent="28" name="product_id">
      <Position>2</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="78" parent="28" name="title">
      <Position>3</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="79" parent="28" name="price">
      <Position>4</Position>
      <DataType>float|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;0&apos;</DefaultExpression>
    </column>
    <key id="80" parent="28" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <column id="81" parent="29" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="82" parent="29" name="user_id">
      <Position>2</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="83" parent="29" name="status">
      <Position>3</Position>
      <DataType>enum(&apos;0&apos;, &apos;1&apos;)|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;0&apos;</DefaultExpression>
    </column>
    <column id="84" parent="29" name="date">
      <Position>4</Position>
      <DataType>timestamp|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>CURRENT_TIMESTAMP</DefaultExpression>
    </column>
    <column id="85" parent="29" name="update_at">
      <Position>5</Position>
      <DataType>timestamp|0</DataType>
    </column>
    <column id="86" parent="29" name="currency">
      <Position>6</Position>
      <DataType>varchar(10)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="87" parent="29" name="note">
      <Position>7</Position>
      <DataType>text|0</DataType>
    </column>
    <key id="88" parent="29" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <column id="89" parent="30" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="90" parent="30" name="order_id">
      <Position>2</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="91" parent="30" name="product_id">
      <Position>3</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="92" parent="30" name="qty">
      <Position>4</Position>
      <DataType>int(11)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="93" parent="30" name="title">
      <Position>5</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="94" parent="30" name="price">
      <Position>6</Position>
      <DataType>float|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <index id="95" parent="30" name="order_id">
      <ColNames>order_id</ColNames>
    </index>
    <key id="96" parent="30" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <foreign-key id="97" parent="30" name="order_product_ibfk_1">
      <ColNames>order_id</ColNames>
      <RefSchemaName>ishop2</RefSchemaName>
      <RefTableName>order</RefTableName>
      <RefColNames>id</RefColNames>
      <OnUpdate>cascade</OnUpdate>
      <OnDelete>cascade</OnDelete>
    </foreign-key>
    <column id="98" parent="31" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="99" parent="31" name="category_id">
      <Position>2</Position>
      <DataType>tinyint(3) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="100" parent="31" name="brand_id">
      <Position>3</Position>
      <DataType>tinyint(3) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="101" parent="31" name="title">
      <Position>4</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="102" parent="31" name="alias">
      <Position>5</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="103" parent="31" name="content">
      <Position>6</Position>
      <DataType>text|0</DataType>
    </column>
    <column id="104" parent="31" name="price">
      <Position>7</Position>
      <DataType>float|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;0&apos;</DefaultExpression>
    </column>
    <column id="105" parent="31" name="old_price">
      <Position>8</Position>
      <DataType>float|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;0&apos;</DefaultExpression>
    </column>
    <column id="106" parent="31" name="status">
      <Position>9</Position>
      <DataType>enum(&apos;0&apos;, &apos;1&apos;)|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;1&apos;</DefaultExpression>
    </column>
    <column id="107" parent="31" name="keywords">
      <Position>10</Position>
      <DataType>varchar(255)|0</DataType>
    </column>
    <column id="108" parent="31" name="description">
      <Position>11</Position>
      <DataType>varchar(255)|0</DataType>
    </column>
    <column id="109" parent="31" name="img">
      <Position>12</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;no_image.jpg&apos;</DefaultExpression>
    </column>
    <column id="110" parent="31" name="hit">
      <Position>13</Position>
      <DataType>enum(&apos;0&apos;, &apos;1&apos;)|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;0&apos;</DefaultExpression>
    </column>
    <index id="111" parent="31" name="alias">
      <ColNames>alias</ColNames>
      <Unique>1</Unique>
    </index>
    <index id="112" parent="31" name="category_id">
      <ColNames>category_id
brand_id</ColNames>
    </index>
    <index id="113" parent="31" name="hit">
      <ColNames>hit</ColNames>
    </index>
    <key id="114" parent="31" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <key id="115" parent="31" name="alias">
      <ColNames>alias</ColNames>
      <UnderlyingIndexName>alias</UnderlyingIndexName>
    </key>
    <column id="116" parent="32" name="product_id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="117" parent="32" name="related_id">
      <Position>2</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <key id="118" parent="32" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>product_id
related_id</ColNames>
      <Primary>1</Primary>
    </key>
    <column id="119" parent="33" name="id">
      <Position>1</Position>
      <DataType>int(10) unsigned|0</DataType>
      <NotNull>1</NotNull>
      <SequenceIdentity>1</SequenceIdentity>
    </column>
    <column id="120" parent="33" name="login">
      <Position>2</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="121" parent="33" name="password">
      <Position>3</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="122" parent="33" name="email">
      <Position>4</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="123" parent="33" name="name">
      <Position>5</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="124" parent="33" name="address">
      <Position>6</Position>
      <DataType>varchar(255)|0</DataType>
      <NotNull>1</NotNull>
    </column>
    <column id="125" parent="33" name="role">
      <Position>7</Position>
      <DataType>enum(&apos;user&apos;, &apos;admin&apos;)|0</DataType>
      <NotNull>1</NotNull>
      <DefaultExpression>&apos;user&apos;</DefaultExpression>
    </column>
    <index id="126" parent="33" name="email">
      <ColNames>email</ColNames>
      <Unique>1</Unique>
    </index>
    <index id="127" parent="33" name="login">
      <ColNames>login</ColNames>
      <Unique>1</Unique>
    </index>
    <key id="128" parent="33" name="PRIMARY">
      <NameSurrogate>1</NameSurrogate>
      <ColNames>id</ColNames>
      <Primary>1</Primary>
    </key>
    <key id="129" parent="33" name="login">
      <ColNames>login</ColNames>
      <UnderlyingIndexName>login</UnderlyingIndexName>
    </key>
    <key id="130" parent="33" name="email">
      <ColNames>email</ColNames>
      <UnderlyingIndexName>email</UnderlyingIndexName>
    </key>
  </database-model>
</dataSource>